#读取测试用例表格
import json

import openpyxl
from openpyxl.workbook import Workbook
from openpyxl.worksheet.worksheet import Worksheet


class doExe():
    def doExeRead(self,f,sname,minr,maxr,minc,maxc):
        wk:Workbook=openpyxl.load_workbook(f)
        st:Worksheet=wk[sname]
        w=st.iter_rows(minr,maxr,minc,maxc,values_only=True)
        l=[i for i in w]
        print(l)
        return l


if __name__=='__main__':
    d=doExe()
    # f=r'D:\RCe\Rce\RCeJieKouzdh\datas\wukongjiekou.xlsx'
    # a=d.doExeRead(f,'deng',2,12,3,7)
    # aa=a[0][3]
    # print(aa,type(aa))
    # d=json.loads(aa)
    # print(d,type(d))
    #字典转成str
    # c=json.dumps(d)
    # print(c,type(c))
    # d.doExeRead(f,'login',2,4,1,4)
    # print(d.doExeRead(f, 'deng', 2, 4, 1, 4))













